package org.web2024.mapper;


import org.apache.ibatis.annotations.CacheNamespace;
import org.apache.ibatis.annotations.Mapper;
import org.web2024.dao.Course;
import org.web2024.dao.Student;
import org.web2024.service.serviceimp.MybatisRedisCache;

import java.util.HashMap;
import java.util.List;



@Mapper
public interface StudentMapper {
    List<Course> showSelectedCourse(String sno, String selCyear);
    List<Course> showAllCourse();
    Student showStudentInfo(String sno);
    List<Course> showOptionalCourse(String typestr,String selCyear);
    boolean modifyStudentinfo(String sno,String s_email);
    Course searchCourse(String c_no);
    Integer getCoin(String s_no,String c_no);
    boolean  confirmCourse(String c_no,String s_no);

    List<Student> showAllStudent();
    boolean admModifyStuInfo(Student student);
    List<Course> stuCourseInfo(HashMap<String,String>data);
    List<String> selectAllsno();
}